Position Property

Returns or sets the position of the object.

Read/write ChartAxisPositionEnum for the ChAxis object.

ChartAxisPositionEnum can be one of these ChartAxisPositionEnum constants.

chAxisPositionBottom

chAxisPositionCategory

chAxisPositionCircular

chAxisPositionLeft

chAxisPositionPrimary

chAxisPositionRadial

chAxisPositionRight

chAxisPositionSecondary

chAxisPositionSeries

chAxisPositionTimescale

chAxisPositionTop

chAxisPositionValue

Read/write ChartDataLabelPositionEnum for the ChDataLabels object.

ChartDataLabelPositionEnum can be one of these ChartDataLabelPositionEnum constants.

chLabelPositionAutomatic

chLabelPositionBottom

chLabelPositionCenter

chLabelPositionInsideBase

chLabelPositionInsideEnd

chLabelPositionLeft

chLabelPositionOutsideBase

chLabelPositionOutsideEnd

chLabelPositionRight

chLabelPositionTop

Read/write ChartLegendPositionEnum for the ChLegend object.

ChartLegendPositionEnum can be one of these ChartLegendPositionEnum constants.

chLegendPositionAutomatic

chLegendPositionBottom

chLegendPositionLeft

chLegendPositionRight

chLegendPositionTop

Read/write ChartTitlePositionEnum for the ChTitle object.

ChartTitlePositionEnum can be one of these ChartTitlePositionEnum constants.

chTitlePositionAutomatic

chTitlePositionBottom

chTitlePositionLeft

chTitlePositionRight

chTitlePositionTop

expression.Position

expression Required. An expression that returns one of the objects in the Applies To list.

Example

This example puts the legend for the specified chart to the left of the plot area.

Sub AddLegend()

   Dim chConstants

   Set chConstants = ChartSpace1.Constants

   ' Enbable the legend for the first chart in Chartspace1.
   ChartSpace1.Charts(0).HasLegend = True

   ' Set the position of the legend.
   ChartSpace1.Charts(0).Legend.Position = chConstants.chLegendPositionLeft

End Sub